package com.zz.ecommerce.declareManage.common.dao;

import com.zz.ecommerce.common.CommonDao;
import com.zz.ecommerce.pojo.TECancelConsumption;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;
import org.springframework.stereotype.Repository;

/**
 * Created by Administrator on 2015/8/17.
 */
@Repository
public interface ECancelConsumptionDao extends CommonDao<TECancelConsumption> {

    //yourself method

    @Select("SELECT NVL(MAX(SEQ_NO)+1,1) FROM ${tableName} T WHERE T.RELATE_ID=#{relateId}\n")
    int getNextSeqNo(@Param("tableName") String tableName, @Param("relateId") String relateId);

}
